//===============================================================================
// Microsoft patterns & practices
// Web Client Software Factory
//-------------------------------------------------------------------------------
// Copyright (C) Microsoft Corporation.  All rights reserved.
// THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY
// OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT
// LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
// FITNESS FOR A PARTICULAR PURPOSE.
//-------------------------------------------------------------------------------
// The example companies, organizations, products, domain names,
// e-mail addresses, logos, people, places, and events depicted
// herein are fictitious.  No association with any real company,
// organization, product, domain name, email address, logo, person,
// places, or events is intended or should be inferred.
//===============================================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Reflection;
using System.Threading;
using System.Diagnostics;

namespace WCSFContrib.PageFlow.Storage.EnterpriseLibrary.Tests
{
    public static class SetupDatabaseUtility
    {
        private static bool databaseInitialized = false;

        internal static void Setup()
        {
            if (!databaseInitialized)
            {
                databaseInitialized = true;

                File.WriteAllText("SetupDatabase.cmd", GetResource(@"WCSFContrib.PageFlow.Storage.EnterpriseLibrary.Tests.Scripts.SetupDatabase.cmd"));
                File.WriteAllText("CreateDatabase.sql", GetResource(@"WCSFContrib.PageFlow.Storage.EnterpriseLibrary.Tests.Scripts.CreateDatabase.sql"));
                File.WriteAllText("pageflowinstancestore.sql", GetResource(@"WCSFContrib.PageFlow.Storage.EnterpriseLibrary.Tests.Scripts.pageflowinstancestore.sql"));

                Process executingProcess = Process.Start("SetupDatabase.cmd");

                while (executingProcess.HasExited == false)
                    Thread.Sleep(500);
            }
        }

        private static string GetResource(string resourceName)
        {
            Assembly assembly = Assembly.GetExecutingAssembly();
            TextReader textReader = new StreamReader(assembly.GetManifestResourceStream(resourceName));
            string result = textReader.ReadToEnd();
            textReader.Close();

            return result;
        }
    }
}
